
alter table purchases_instructions_details
	drop column item_id
go

create table purchases_instructions_items_details (
	purchase_instruction_item_detail_id int identity(1,1) not null primary key,
	purchase_instruction_detail_id int not null,
	item_id char(16) not null
)
go

alter table purchases_instructions_items_details add constraint fk_pid_piid foreign key(purchase_instruction_detail_id) references purchases_instructions_details(purchase_instruction_detail_id)
go
